
        <!DOCTYPE html>
        <html lang="en">
        <head>
            <meta charset="UTF-8">
            <meta name="viewport" content="width=device-width, initial-scale=1.0">
            <title>Text2SQL Evaluation Report</title>
            <style>
                * { margin: 0; padding: 0; box-sizing: border-box; }
                body { 
                    font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif; 
                    line-height: 1.6; 
                    color: #333; 
                    background: #f8f9fa;
                }
                .container { max-width: 1200px; margin: 0 auto; padding: 20px; }
                .header { 
                    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
                    color: white; 
                    padding: 30px; 
                    border-radius: 12px; 
                    margin-bottom: 30px;
                    box-shadow: 0 4px 6px rgba(0,0,0,0.1);
                }
                .header h1 { font-size: 2.5em; margin-bottom: 10px; font-weight: 300; }
                .header .subtitle { font-size: 1.1em; opacity: 0.9; }
                .metrics-grid { 
                    display: grid; 
                    grid-template-columns: repeat(auto-fit, minmax(280px, 1fr)); 
                    gap: 20px; 
                    margin: 30px 0; 
                }
                .metric-card { 
                    background: white; 
                    border-radius: 12px; 
                    padding: 25px; 
                    box-shadow: 0 2px 10px rgba(0,0,0,0.08);
                    border-left: 4px solid #667eea;
                    transition: transform 0.2s ease;
                }
                .metric-card:hover { transform: translateY(-2px); }
                .metric-title { 
                    font-size: 1.1em; 
                    font-weight: 600; 
                    color: #555; 
                    margin-bottom: 15px;
                    text-transform: uppercase;
                    letter-spacing: 0.5px;
                }
                .metric-value { 
                    font-size: 2.5em; 
                    font-weight: 700; 
                    color: #667eea; 
                    margin-bottom: 10px;
                }
                .metric-detail { 
                    color: #666; 
                    font-size: 0.9em; 
                    margin: 5px 0;
                }
                .section { 
                    background: white; 
                    border-radius: 12px; 
                    padding: 25px; 
                    margin: 20px 0; 
                    box-shadow: 0 2px 10px rgba(0,0,0,0.08);
                }
                .section h2 { 
                    color: #333; 
                    margin-bottom: 20px; 
                    font-size: 1.5em;
                    border-bottom: 2px solid #667eea;
                    padding-bottom: 10px;
                }
                .data-table { 
                    width: 100%; 
                    border-collapse: collapse; 
                    margin-top: 15px;
                    background: white;
                    border-radius: 8px;
                    overflow: hidden;
                }
                .data-table th { 
                    background: #f8f9fa; 
                    padding: 15px 12px; 
                    text-align: left; 
                    font-weight: 600;
                    color: #555;
                    border-bottom: 2px solid #e9ecef;
                }
                .data-table td { 
                    padding: 12px; 
                    border-bottom: 1px solid #e9ecef; 
                }
                .data-table tr:hover { background: #f8f9fa; }
                .status-success { color: #28a745; font-weight: 600; }
                .status-error { color: #dc3545; font-weight: 600; }
                .progress-bar { 
                    background: #e9ecef; 
                    border-radius: 10px; 
                    height: 8px; 
                    margin: 5px 0;
                }
                .progress-fill { 
                    background: linear-gradient(90deg, #667eea, #764ba2); 
                    height: 100%; 
                    border-radius: 10px;
                    transition: width 0.3s ease;
                }
                .footer { 
                    text-align: center; 
                    margin-top: 40px; 
                    padding: 20px; 
                    color: #666;
                    font-size: 0.9em;
                }
            </style>
        </head>
        <body>
            <div class="container">
                <div class="header">
                    <h1>Text2SQL Evaluation Report</h1>
                    <div class="subtitle">
                        Generated on 2025-09-26T09:31:22.426436 | 
                        15 queries processed | 
                        Duration: 86.11s
                    </div>
                </div>
            
                <div class="metrics-grid">
                    
                    <div class="metric-card">
                        <div class="metric-title">Execution Accuracy</div>
                        <div class="metric-value">86.7%</div>
                        <div class="metric-detail">Success Rate: 86.7%</div>
                        <div class="progress-bar">
                            <div class="progress-fill" style="width: 86.7%"></div>
                        </div>
                    </div>
                    
                    <div class="metric-card">
                        <div class="metric-title">Syntax Accuracy</div>
                        <div class="metric-value">100.0%</div>
                        <div class="metric-detail">Valid Rate: 100.0%</div>
                        <div class="progress-bar">
                            <div class="progress-fill" style="width: 100.0%"></div>
                        </div>
                    </div>
                    
                    <div class="metric-card">
                        <div class="metric-title">Semantic Similarity</div>
                        <div class="metric-value">100.0%</div>
                        <div class="progress-bar">
                            <div class="progress-fill" style="width: 100.0%"></div>
                        </div>
                    </div>
                    
                    <div class="metric-card">
                        <div class="metric-title">Retrieval Recall</div>
                        <div class="metric-value">50.4%</div>
                        <div class="metric-detail">Table: 73.3%</div>
                        <div class="metric-detail">Column: 20.0%</div>
                        <div class="metric-detail">Key Column: 22.9%</div>
                        <div class="metric-detail">Weighted: 50.4%</div>
                        <div class="progress-bar">
                            <div class="progress-fill" style="width: 50.4%"></div>
                        </div>
                    </div>
                    
                    <div class="metric-card">
                        <div class="metric-title">Overall Score</div>
                        <div class="metric-value">84.7%</div>
                        <div class="progress-bar">
                            <div class="progress-fill" style="width: 84.7%"></div>
                        </div>
                    </div>
                </div>
            
                <div class="section">
                    <h2>Detailed Analysis</h2>
                    <div class="metrics-grid">
                        <div class="metric-card">
                            <div class="metric-title">Table Analysis</div>
                            <div class="metric-detail">Expected: 15</div>
                            <div class="metric-detail">Retrieved: 32</div>
                            <div class="metric-detail">Matched: 11</div>
                            <div class="metric-detail">Precision: 34.4%</div>
                            <div class="metric-detail">Recall: 73.3%</div>
                        </div>
                        
                        <div class="metric-card">
                            <div class="metric-title">Column Analysis</div>
                            <div class="metric-detail">Expected: 61</div>
                            <div class="metric-detail">Retrieved: 399</div>
                            <div class="metric-detail">Matched: 18</div>
                            <div class="metric-detail">Precision: 4.5%</div>
                            <div class="metric-detail">Recall: 29.5%</div>
                        </div>
                        
                        <div class="metric-card">
                            <div class="metric-title">Key Column Analysis</div>
                            <div class="metric-detail">Expected: 26</div>
                            <div class="metric-detail">Matched: 10</div>
                            <div class="metric-detail">Recall: 38.5%</div>
                            <div class="metric-detail">Coverage: 11.1%</div>
                        </div>
                        
                        <div class="metric-card">
                            <div class="metric-title">SQL Type Distribution</div>
                            <div class='metric-detail'>UNKNOWN: 15</div>
                        </div>
                    </div>
                </div>
                
                <div class="section">
                    <h2>Query Results</h2>
                    <table class="data-table">
                        <thead>
                            <tr>
                                <th>ID</th>
                                <th>Query</th>
                                <th>Execution</th>
                                <th>Syntax</th>
                                <th>Semantic</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
        
                            <tr>
                                <td>1</td>
                                <td>List all actors with their IDs and names....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>2</td>
                                <td>Add a new actor named 'John Doe'....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>3</td>
                                <td>Update the last name of actor with ID 1 to 'Smith'....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>4</td>
                                <td>Delete the actor with ID 2....</td>
                                <td>0.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>5</td>
                                <td>Show all films and their descriptions....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>6</td>
                                <td>Insert a new film titled 'New Movie' in language 1....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>7</td>
                                <td>Change the rating of film ID 3 to 'PG-13'....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>8</td>
                                <td>Remove the film with ID 4....</td>
                                <td>0.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>9</td>
                                <td>Retrieve all categories....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>10</td>
                                <td>Add a new category 'Horror'....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>11</td>
                                <td>List all customers with their store and email....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>12</td>
                                <td>Show inventory items for film ID 5....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>13</td>
                                <td>List recent rentals with rental date and customer....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>14</td>
                                <td>Show all payments with amount and date....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                            <tr>
                                <td>15</td>
                                <td>List all staff with names and email....</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td>100.0%</td>
                                <td class="status-success">Success</td>
                            </tr>
            
                        </tbody>
                    </table>
                </div>
                
                <div class="footer">
                    <p>Generated by Text2SQL Evaluation System | Professional Assessment Framework</p>
                </div>
            </div>
        </body>
        </html>
        